Homogeneous Replication
When replicating from a Google Cloud SQL for PostrgreSQL source to a Google Cloud SQL for PostrgreSQL target, most of the source and target data types will be identical. The exceptions are listed in the table below.
Additionally, in homogeneous replication, source column and table collations will be replicated to the target as described in Column and table collation.
In homogeneous replication, the source data first passes through the Qlik Replicate data type and is therefore subject to any limitations of that type.
For information on Replicate data types and their limitations (where relevant), see Replicate data types.
For information on which Replicate data types the source data passes through when replicating from Google Cloud SQL for PostgreSQL, see the Google Cloud SQL for PostgreSQL to Qlik Replicate data types mapping table described earlier.
Replication of Partitioned Tables
In order to replicate partitioned tables from a Google Cloud SQL for PostgreSQL source to a Google Cloud SQL for PostgreSQL target, you need to do the following:
- Manually create the parent and child tables in the target database.
- Define a separate task to replicate to those tables.
- Set the Truncate before loading option in the Full Load Settings.